﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using CCOMDataAccess;

public partial class News : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (HttpContext.Current.Request["NewsCategory"] != null)
        {
            NewsLoad(int.Parse(HttpContext.Current.Request["NewsCategory"]));
        }
        else
        {
            NewsLoad(int.Parse("1"));
        }
    }

    private void NewsLoad(int NewsCategory)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        var NewsList = from n in db.News
                       where n.NewsCategory == NewsCategory
                       select new
                       {
                           NOTAM = n.NOTAM,
                           Object = n.Object,
                           User = n.User1.Name,
                           PublishedDate = n.PublishedDate,
                           Category = n.NewsCategory1.Name,
                           Text = n.Text
                       };
        rNews.DataSource = NewsList.Take(3);
        rNews.DataBind();
    }
}
